Tabulate "spreadsheets" contain one or more Sheets. Using individual sheets allows you to organize and understand your data more clearly. As in any spreadsheet tool, these sheets are navigated between using tabs.
You can also add, delete, rename, and navigate between sheets in the tabbed header (red) or the Sheets panel (orange).
Note: Above the tabs are the fields used to interact with any formulas associated with the data in the selected cell or cells. For more information, see Working With Formulas.
Sheet Operations
The following core sheet-level operations are driven through the sheet controls.
|
Function |
Present in |
Description |
|---|---|---|
|
Sheets panel |
Right-click Rename Sheet. |
|
|
Sheets panel; Tabbed header |
Use the left and right arrows to navigate to the previous or next sheet in the Tabulation. Tip: Alternatively, use the hamburger menu or Sheets panel. Note: These arrows are only enabled when there's not enough space to show all tabs (indicated by an ellipsis). |
|
|
Sheets panel; Tabbed header |
Click the plus icon to add a Sheet. By default, the new sheet is named Sheetn, where "n" is the next number in the sequence. Note: You can also add a sheet by right-clicking an existing sheet name and selecting Insert from the drop-down menu. |
|
|
Sheets panel; Tabbed header |
Right-click Sheet Name > Delete. |
|
|
Sheets panel; Tabbed header |
Drag and drop the Sheet Name tab. |
|
|
Tabbed header |
Right-click Sheet Name > Hide to hide the tab. Right-click Sheet Name > Unhide to show the tab. |
